Update Excel
(Operator Toolbox)
Synopsis
This operator allows updating individual cells and entire tables in Excel spreadsheets.Description
This operator allows replacing the contents of individual cells or entire tables in an Excel spreadsheet. Both cells and tables are referenced by their name, e.g., A1 or Table1.
When updating a table, the operator will automatically adjust the number of rows and update charts, formatting rules, and names referencing the data. The operator does not support changing the number of columns: the input data must always have the same number of columns as the spreadsheet table.
The operator has limited support for reevaluating formulas: it can revaluate simple expressions but does not support all Excel functions. Formula reevaluation can be disabled using the respective parameter.
Input
file (File)The Excel spreadsheet to update.
data (Data Table)The data table to update the spreadsheet with (if any).
Output
- file (File)
The updated Excel spreadsheet.
- through (Data Table)
The input data table (if any).
Parameters
- element The spreadsheet element to update.
- sheet The name of the sheet to update.
- cell The cell to update (e.g., A1).
- value The value to update the cell with (text or numeric).
- table The name of the table to update.
- timezone The timezone to use for writing date-time cells.
- update formulas Evaluate formulas and update cached values.